/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package DAOInterface;

import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.util.ArrayList;

/**
 *
 * @author Fabian
 */
public interface DAOConnection {
    
    /**
     * 
     * @return
     */
    public DatabaseMetaData getModel();
    /**
     * 
     * @param tabla
     * @param columna
     * @return
     */
    public ResultSet getColumn(String tabla, String columna);
    /**
     * 
     * @param path
     * @param dbName
     * @param user
     * @param pass
     * @return
     */
    public boolean setConnection(String path, String dbName, String user, String pass);
    /**
     * 
     * @param tabla
     * @param columnas
     * @param parametros
     */
    public void createElement(String tabla, ArrayList columnas, ArrayList parametros);
    /**
     * 
     * @param tabla
     * @param columnas
     * @param filtro
     * @return
     */
    public ResultSet getElement(String tabla, ArrayList columnas, String filtro);
    /**
     * 
     * @return
     */
    public boolean openConnection();
    /**
     * 
     */
    public void closeConnection();
    /**
     * 
     * @param tabla
     * @return
     */
    public String getPK(String tabla);
    /**
     * 
     * @return
     */
    public String getLastQuery();
    
}
